using System;
using System.Collections.Generic;
using System.Text;
using Shc.Sql;
using Shc.Json;
namespace CLZ.Data
{
	public static class TableViewEXWarehouseGoodsList
	{
		public const string Table = "View_EXWarehouseGoodsList";
		public const string EXWarehouseGoodsID = "EXWarehouseGoodsID";
		public const string EXWarehouseID = "EXWarehouseID";
		public const string VegetablesID = "VegetablesID";
		public const string OrderItemID = "OrderItemID";
		public const string SalesGuidePrice = "SalesGuidePrice";
		public const string TotalQty = "TotalQty";
		public const string VegetablesName = "VegetablesName";
		public const string VegetablesNo = "VegetablesNo";
		public const string Description = "Description";
		public const string Creater = "Creater";
		public const string CreatedBy = "CreatedBy";
		public const string Created = "Created";
		public const string Modified = "Modified";
		public const string ModifiedBy = "ModifiedBy";
		public const string ModifiedByID = "ModifiedByID";
		public const string VegetablesTypeID = "VegetablesTypeID";
		public const string NumberOfUnitsID = "NumberOfUnitsID";
		public const string Expr1 = "Expr1";
		public const string VegetablesStatus = "VegetablesStatus";
		public const string ImageUrl = "ImageUrl";
		public const string Specification = "Specification";
		public const string Expr2 = "Expr2";
		public const string CookingMethods = "CookingMethods";
		public const string Expr3 = "Expr3";
		public const string Weigth = "Weigth";
		public const string ProductType = "ProductType";
		public const string VegetablesTypeName = "VegetablesTypeName";
		public const string ProductCategoryID = "ProductCategoryID";
		public const string CategoryName = "CategoryName";
		public const string NumberOfUnitsName = "NumberOfUnitsName";
	}
	
	[Serializable]
	public class BaseViewEXWarehouseGoodsList
		: IDbSessionEntity, IJsonClass
	{
		int m_EXWarehouseGoodsID;
		/// <summary>
        /// 
        /// </summary>
        public int EXWarehouseGoodsID
        {
            get { return m_EXWarehouseGoodsID; }
            set { m_EXWarehouseGoodsID = value; }
        }
		
		int? m_EXWarehouseID;
		/// <summary>
        /// 
        /// </summary>
        public int? EXWarehouseID
        {
            get { return m_EXWarehouseID; }
            set { m_EXWarehouseID = value; }
        }
		
		int? m_VegetablesID;
		/// <summary>
        /// 
        /// </summary>
        public int? VegetablesID
        {
            get { return m_VegetablesID; }
            set { m_VegetablesID = value; }
        }
		
		int m_OrderItemID;
		/// <summary>
        /// 
        /// </summary>
        public int OrderItemID
        {
            get { return m_OrderItemID; }
            set { m_OrderItemID = value; }
        }
		
		double m_SalesGuidePrice;
		/// <summary>
        /// 
        /// </summary>
        public double SalesGuidePrice
        {
            get { return m_SalesGuidePrice; }
            set { m_SalesGuidePrice = value; }
        }
		
		double m_TotalQty;
		/// <summary>
        /// 
        /// </summary>
        public double TotalQty
        {
            get { return m_TotalQty; }
            set { m_TotalQty = value; }
        }
		
		string m_VegetablesName;
		/// <summary>
        /// 
        /// </summary>
        public string VegetablesName
        {
            get { return m_VegetablesName; }
            set { m_VegetablesName = value; }
        }
		
		string m_VegetablesNo;
		/// <summary>
        /// 
        /// </summary>
        public string VegetablesNo
        {
            get { return m_VegetablesNo; }
            set { m_VegetablesNo = value; }
        }
		
		string m_Description;
		/// <summary>
        /// 
        /// </summary>
        public string Description
        {
            get { return m_Description; }
            set { m_Description = value; }
        }
		
		int m_Creater;
		/// <summary>
        /// 
        /// </summary>
        public int Creater
        {
            get { return m_Creater; }
            set { m_Creater = value; }
        }
		
		string m_CreatedBy;
		/// <summary>
        /// 
        /// </summary>
        public string CreatedBy
        {
            get { return m_CreatedBy; }
            set { m_CreatedBy = value; }
        }
		
		DateTime m_Created;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Created
        {
            get { return m_Created; }
            set { m_Created = value; }
        }
		
		DateTime m_Modified;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Modified
        {
            get { return m_Modified; }
            set { m_Modified = value; }
        }
		
		string m_ModifiedBy;
		/// <summary>
        /// 
        /// </summary>
        public string ModifiedBy
        {
            get { return m_ModifiedBy; }
            set { m_ModifiedBy = value; }
        }
		
		int? m_ModifiedByID;
		/// <summary>
        /// 
        /// </summary>
        public int? ModifiedByID
        {
            get { return m_ModifiedByID; }
            set { m_ModifiedByID = value; }
        }
		
		int? m_VegetablesTypeID;
		/// <summary>
        /// 
        /// </summary>
        public int? VegetablesTypeID
        {
            get { return m_VegetablesTypeID; }
            set { m_VegetablesTypeID = value; }
        }
		
		int? m_NumberOfUnitsID;
		/// <summary>
        /// 
        /// </summary>
        public int? NumberOfUnitsID
        {
            get { return m_NumberOfUnitsID; }
            set { m_NumberOfUnitsID = value; }
        }
		
		string m_Expr1;
		/// <summary>
        /// 
        /// </summary>
        public string Expr1
        {
            get { return m_Expr1; }
            set { m_Expr1 = value; }
        }
		
		int m_VegetablesStatus;
		/// <summary>
        /// 
        /// </summary>
        public int VegetablesStatus
        {
            get { return m_VegetablesStatus; }
            set { m_VegetablesStatus = value; }
        }
		
		string m_ImageUrl;
		/// <summary>
        /// 
        /// </summary>
        public string ImageUrl
        {
            get { return m_ImageUrl; }
            set { m_ImageUrl = value; }
        }
		
		string m_Specification;
		/// <summary>
        /// 
        /// </summary>
        public string Specification
        {
            get { return m_Specification; }
            set { m_Specification = value; }
        }
		
		string m_Expr2;
		/// <summary>
        /// 
        /// </summary>
        public string Expr2
        {
            get { return m_Expr2; }
            set { m_Expr2 = value; }
        }
		
		string m_CookingMethods;
		/// <summary>
        /// 
        /// </summary>
        public string CookingMethods
        {
            get { return m_CookingMethods; }
            set { m_CookingMethods = value; }
        }
		
		string m_Expr3;
		/// <summary>
        /// 
        /// </summary>
        public string Expr3
        {
            get { return m_Expr3; }
            set { m_Expr3 = value; }
        }
		
		double m_Weigth;
		/// <summary>
        /// 
        /// </summary>
        public double Weigth
        {
            get { return m_Weigth; }
            set { m_Weigth = value; }
        }
		
		int m_ProductType;
		/// <summary>
        /// 
        /// </summary>
        public int ProductType
        {
            get { return m_ProductType; }
            set { m_ProductType = value; }
        }
		
		string m_VegetablesTypeName;
		/// <summary>
        /// 
        /// </summary>
        public string VegetablesTypeName
        {
            get { return m_VegetablesTypeName; }
            set { m_VegetablesTypeName = value; }
        }
		
		int? m_ProductCategoryID;
		/// <summary>
        /// 
        /// </summary>
        public int? ProductCategoryID
        {
            get { return m_ProductCategoryID; }
            set { m_ProductCategoryID = value; }
        }
		
		string m_CategoryName;
		/// <summary>
        /// 
        /// </summary>
        public string CategoryName
        {
            get { return m_CategoryName; }
            set { m_CategoryName = value; }
        }
		
		string m_NumberOfUnitsName;
		/// <summary>
        /// 
        /// </summary>
        public string NumberOfUnitsName
        {
            get { return m_NumberOfUnitsName; }
            set { m_NumberOfUnitsName = value; }
        }
		
		
		#region IDbSessionEntity Members
		public void ReadDBData(RowDataReader reader)
        {
            m_EXWarehouseGoodsID = reader[TableViewEXWarehouseGoodsList.EXWarehouseGoodsID];
            m_EXWarehouseID = reader[TableViewEXWarehouseGoodsList.EXWarehouseID];
            m_VegetablesID = reader[TableViewEXWarehouseGoodsList.VegetablesID];
            m_OrderItemID = reader[TableViewEXWarehouseGoodsList.OrderItemID];
            m_SalesGuidePrice = reader[TableViewEXWarehouseGoodsList.SalesGuidePrice];
            m_TotalQty = reader[TableViewEXWarehouseGoodsList.TotalQty];
            m_VegetablesName = reader[TableViewEXWarehouseGoodsList.VegetablesName];
            m_VegetablesNo = reader[TableViewEXWarehouseGoodsList.VegetablesNo];
            m_Description = reader[TableViewEXWarehouseGoodsList.Description];
            m_Creater = reader[TableViewEXWarehouseGoodsList.Creater];
            m_CreatedBy = reader[TableViewEXWarehouseGoodsList.CreatedBy];
            m_Created = reader[TableViewEXWarehouseGoodsList.Created];
            m_Modified = reader[TableViewEXWarehouseGoodsList.Modified];
            m_ModifiedBy = reader[TableViewEXWarehouseGoodsList.ModifiedBy];
            m_ModifiedByID = reader[TableViewEXWarehouseGoodsList.ModifiedByID];
            m_VegetablesTypeID = reader[TableViewEXWarehouseGoodsList.VegetablesTypeID];
            m_NumberOfUnitsID = reader[TableViewEXWarehouseGoodsList.NumberOfUnitsID];
            m_Expr1 = reader[TableViewEXWarehouseGoodsList.Expr1];
            m_VegetablesStatus = reader[TableViewEXWarehouseGoodsList.VegetablesStatus];
            m_ImageUrl = reader[TableViewEXWarehouseGoodsList.ImageUrl];
            m_Specification = reader[TableViewEXWarehouseGoodsList.Specification];
            m_Expr2 = reader[TableViewEXWarehouseGoodsList.Expr2];
            m_CookingMethods = reader[TableViewEXWarehouseGoodsList.CookingMethods];
            m_Expr3 = reader[TableViewEXWarehouseGoodsList.Expr3];
            m_Weigth = reader[TableViewEXWarehouseGoodsList.Weigth];
            m_ProductType = reader[TableViewEXWarehouseGoodsList.ProductType];
            m_VegetablesTypeName = reader[TableViewEXWarehouseGoodsList.VegetablesTypeName];
            m_ProductCategoryID = reader[TableViewEXWarehouseGoodsList.ProductCategoryID];
            m_CategoryName = reader[TableViewEXWarehouseGoodsList.CategoryName];
            m_NumberOfUnitsName = reader[TableViewEXWarehouseGoodsList.NumberOfUnitsName];
        }
		
		public void WriteDBData(RowDataWriter writer)
        {
        }

        public void SetIdentityAfterInsert(DBObject idd)
        {
        }
		
		public string TableName
        {
            get { return TableViewEXWarehouseGoodsList.Table; }
        }
		#endregion
		
		
		#region IJsonClass Members

        public void JsonDeSerializeObj(JsonHashTable hashToRead)
        {
             m_EXWarehouseGoodsID = hashToRead["EXWarehouseGoodsID"];
			 
             m_EXWarehouseID = hashToRead["EXWarehouseID"];
			 
             m_VegetablesID = hashToRead["VegetablesID"];
			 
             m_OrderItemID = hashToRead["OrderItemID"];
			 
             m_SalesGuidePrice = hashToRead["SalesGuidePrice"];
			 
             m_TotalQty = hashToRead["TotalQty"];
			 
             m_VegetablesName = hashToRead["VegetablesName"];
			 
             m_VegetablesNo = hashToRead["VegetablesNo"];
			 
             m_Description = hashToRead["Description"];
			 
             m_Creater = hashToRead["Creater"];
			 
             m_CreatedBy = hashToRead["CreatedBy"];
			 
             m_Created = hashToRead["Created"];
			 
             m_Modified = hashToRead["Modified"];
			 
             m_ModifiedBy = hashToRead["ModifiedBy"];
			 
             m_ModifiedByID = hashToRead["ModifiedByID"];
			 
             m_VegetablesTypeID = hashToRead["VegetablesTypeID"];
			 
             m_NumberOfUnitsID = hashToRead["NumberOfUnitsID"];
			 
             m_Expr1 = hashToRead["Expr1"];
			 
             m_VegetablesStatus = hashToRead["VegetablesStatus"];
			 
             m_ImageUrl = hashToRead["ImageUrl"];
			 
             m_Specification = hashToRead["Specification"];
			 
             m_Expr2 = hashToRead["Expr2"];
			 
             m_CookingMethods = hashToRead["CookingMethods"];
			 
             m_Expr3 = hashToRead["Expr3"];
			 
             m_Weigth = hashToRead["Weigth"];
			 
             m_ProductType = hashToRead["ProductType"];
			 
             m_VegetablesTypeName = hashToRead["VegetablesTypeName"];
			 
             m_ProductCategoryID = hashToRead["ProductCategoryID"];
			 
             m_CategoryName = hashToRead["CategoryName"];
			 
             m_NumberOfUnitsName = hashToRead["NumberOfUnitsName"];
			 
        }

        public void JsonSerializeObj(JsonHashTable hashToFill)
        {
            hashToFill["EXWarehouseGoodsID"] = EXWarehouseGoodsID;
			
            hashToFill["EXWarehouseID"] = EXWarehouseID;
			
            hashToFill["VegetablesID"] = VegetablesID;
			
            hashToFill["OrderItemID"] = OrderItemID;
			
            hashToFill["SalesGuidePrice"] = SalesGuidePrice;
			
            hashToFill["TotalQty"] = TotalQty;
			
            hashToFill["VegetablesName"] = VegetablesName;
			
            hashToFill["VegetablesNo"] = VegetablesNo;
			
            hashToFill["Description"] = Description;
			
            hashToFill["Creater"] = Creater;
			
            hashToFill["CreatedBy"] = CreatedBy;
			
            hashToFill["Created"] = Created;
			
            hashToFill["Modified"] = Modified;
			
            hashToFill["ModifiedBy"] = ModifiedBy;
			
            hashToFill["ModifiedByID"] = ModifiedByID;
			
            hashToFill["VegetablesTypeID"] = VegetablesTypeID;
			
            hashToFill["NumberOfUnitsID"] = NumberOfUnitsID;
			
            hashToFill["Expr1"] = Expr1;
			
            hashToFill["VegetablesStatus"] = VegetablesStatus;
			
            hashToFill["ImageUrl"] = ImageUrl;
			
            hashToFill["Specification"] = Specification;
			
            hashToFill["Expr2"] = Expr2;
			
            hashToFill["CookingMethods"] = CookingMethods;
			
            hashToFill["Expr3"] = Expr3;
			
            hashToFill["Weigth"] = Weigth;
			
            hashToFill["ProductType"] = ProductType;
			
            hashToFill["VegetablesTypeName"] = VegetablesTypeName;
			
            hashToFill["ProductCategoryID"] = ProductCategoryID;
			
            hashToFill["CategoryName"] = CategoryName;
			
            hashToFill["NumberOfUnitsName"] = NumberOfUnitsName;
			
        }

        #endregion
		
	}
}
